JSON处理使用Rapidminer金桥运营商

Somnath_DasSomnath_Das 米emberPosts:31米aven
I have simple JSON data in the format as follows:

{"A":"a1","B":"b1"}
{"A":"a2","B":"b2"}
{"A":"a3","B":"b3"}

I want the output in the format:
A B
a1 b1
a2 b2
a3 b3

Please help, it is urgent
Tagged:

Answers

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified ExpertPosts:913Unicorn
    Hi,

    when I try your input on jqplay.org with the filter [.A, .B] |@csv, it returns the correct output.

    The library used in the RapidMiner extension only returns the first element though. I'm not sure what to do there.

    输入有点反常啊,因为这是一个列表f objects, but not in a syntactically explicit way.

    When changing the input to this:
    [
    {"A":"a1","B":"b1"},
    {"A":"a2","B":"b2"},
    {"A":"a3","B":"b3"}
    ]
    it works with the filter.[] | [.A, .B].

    Example process:

    < ?xml version = " 1.0 " encoding = " utf - 8 " ?> <过程版本sion="9.8.001">                                                                               


    With this input the output of "JSON to Data" is also meaningful.


    Regards,

    Balázs

Sign InorRegisterto comment.