assigning value from table to a variable

[ronaldwang]

I have a table where the information is sorted in a particular order. Is there a way I can assign a cell value in a particular position (eg, row 1 column 2) to a variable easily? thanks

[luismadriz]

Hi,

Maybe a double For loop and the Peek function?

[Anil_Babu_Samineni]

Title Looks like this?

LET Variable = Peek('TableName', FieldName, 3);

[ronaldwang]

Thanks, I can do this in load script.

I should have made more clear that I want to assign table value to a variable where the table is in the front end. e,g a table where I have calculated the 50 percentile. if I can not achieve this then I will have to go back to insert this information into the original table.

[Anil_Babu_Samineni]

Can you come up with some sample data and result you want to store in variable, Please?

[woshua5550]

maybe a simple macro can help you , plz check my test file attached

[ronaldwang]

the result table is as below and can be dilemma as user can change the date but the order will be the same, e,g sorting last column from high to low, and I want to assign variable for the 50 percentile of that column to a variable.

Thanks

[ronaldwang]

Thanks, that is a good way of doing it. just curious apart from using marco, any other way to achieve the result.

[woshua5550]

Concat () + Subfield() also works but there will be a lot of limitations

check "Method 2" in attachment