How to create an array from Column Names and values.I have a table that has 3 columns and a single row of values and I am trying to create an Associative array from it,
I have tried this:
Names Default To Here( 1 );
dt = Current Data Table();
keysList = dt << Get Column Names(string);
tablData = Associative Array();
For(i=1, i <= N Items(KeysList), i++,
tablData<< Insert(KeysList[i])
); //end of For
tablData << Get Values;
The array is created but all the values are => 1.
I was expecting : tablData = ["deep" => 40, "length" => 20, "width" => 10];
I will appreciate your help fixing my code.
Data TableScriptingRe: How to create an array from Column Names and values.You could do something like this...
Names Default To Here( 1 );<BR />dt = Current Data Table();<BR />keysList = dt << Get Column Names( string );<BR />tablData = {};<BR />For( i = 1, i <= N Items( KeysList ), i++,<BR />Insert Into( tablData, Column( KeysList[i] )[1] )<BR />); //end of For<BR />aa = Eval List( Associative Array( keysList, tablData ) );
Re: How to create an array from Column Names and values.Hi @Wendy_Murphrey. I had a tried something similar but I always forget the "Eval List". Thank you very much for your help and the lesson.
