topic Re: How to create an array from Column Names and values. in Discussions

How to create an array from Column Names and values.

ALopez — Sat, 10 Jun 2023 23:25:23 GMT

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.

Re: How to create an array from Column Names and values.

Wendy_Murphrey — Wed, 27 Jan 2021 20:57:21 GMT

You could do something like this...

Names Default To Here( 1 );
dt = Current Data Table();
keysList = dt << Get Column Names( string );
tablData = {};
For( i = 1, i <= N Items( KeysList ), i++,
	Insert Into( tablData, Column( KeysList[i] )[1] )
); //end of For
aa = Eval List( Associative Array( keysList, tablData ) );

Re: How to create an array from Column Names and values.

ALopez — Wed, 27 Jan 2021 21:24:47 GMT

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.