Data table number to Data table name with contains and Eval

AlexS

Hello

The code currently works via data table number (dtlist)but what I need is the Eval to find a table based on contains then update it.

so something like Eval(contains(dtlist,("xx4") then update. if that's even possible?

 

Names Default To Here( 1 );
	
dtLIst = {};

For( i = 1, i <= N Table(), i++,
	dt = data table(i);
	insert into(dtList, dt );
);

eval(dtList[4]) << Update(
	With( Data Table( "Sales" ) ),
	Add Columns from Update table( :Name( "XX1" ) ));
	
eval(dtList[5]) << Update(
	With( Data Table( "Sales" ) ),
	Add Columns from Update table( :Name( "XX2" ) ))

many thanks

txnelson

I think this will give you what you want

Names Default To Here( 1 );

For( i = 1, i <= N Table(), i++,
	If( Contains( Data Table( i ) << get name, "XX1" ),
		Break()
	)
);

If( i <= N Table(),
	Data Table( i ) << Update(
		With( Data Table( "Sales" ) ),
		Add Columns from Update table( :Name( "XX1" ) )
	)
);

For( i = 1, i <= N Table(), i++,
	If( Contains( Data Table( i ) << get name, "XX2" ),
		Break()
	)
);

If( i <= N Table(),
	Eval( dtList[5] ) << Update(
		With( Data Table( "Sales" ) ),
		Add Columns from Update table( :Name( "XX2" ) )
	)
);