Hello everyone,
I have a data grid as request variable in my event and I want to save the columns as separate lists.
Example:
df =
ANCILLARY PRICE
"ABC" 20
"DEF" 30
should be converted into
["ABC","DEF"] (character list)
[20,30] (integer list)
I have tried using a process node with Jython code but I wasn't successful using something like
list = df.loc(:,"ANCILLARY") or list = df[["ANCILLARY"]].tolist()
Would be great to get some input on this problem, thanks in advance.
Hi KiKa,
You can do this without code if you would prefer, with the following steps:
Regards
James
Hi James,
thanks for your answer. I tried your suloution and created a new list variable in the assignment node. However, the column of data grids do not appear as a selection option. Maybe this is because RTDM does not recognize the format (character/integer etc) of the columns? Is there a way to assign this for each column of a data grid?
Thanks for the help and best regards,
KiKa
Listen to the Reimagine Marketing podcast
Assess your marketing efforts with a free tool
SAS Customer Intelligence Learning Subscription (login required)
SAS' Peter Ansbacher shows you how to use the dashboard in SAS Customer Intelligence 360 for better results.
Find more tutorials on the SAS Users YouTube channel.
Listen to the Reimagine Marketing podcast
Assess your marketing efforts with a free tool
SAS Customer Intelligence Learning Subscription (login required)