Understand the code

[ishika00730]

Hi,

It would be a help if someone can explain the below code to me:

[$(=concat({1<$Table={'Sales'}>} $Field,']=,['))]=,

Regards

Ishika

[olivierrobin]

it deselects all fields of table Sales

$Field= list of fields

$Table= list of all tables, matching with Sales , so only this table is selected

concat creates a list in this way field1=,field2=, .... fieldN=

and at least $(= interprets the previous result

[ishika00730]

Hi Olivier,

Thank you very much for the answer. I would like to tell you that when I use the above code, it returns me a specific field from that table. Also I tried to replace the table name with other table, in this case also it returns a particular field from the table. I want to understand the logic behind returning a particular field.

[olivierrobin]

as i sayed, for me this code deselects all sélections made with fields from this table

BUT if you have other selections coming from other tables or using set analysis, these sélections remain active

[sasiparupudi1 · Accepted solution]

If you put the code in a text box you can see what the code is doing

Text box 1

=concat({1<$Table={'Sales'}>} $Field,']=[')

You will see all the fields listed in square brackets with a comma delimited except the first and the last

Text box 2

='[' & concat({1<$Table={'Sales'}>} $Field,']=[') &']='

you will see all the fields listed with in square brackets

This piece of code is generally used in set analysis if you wish to disregard the selections of all the fields from a particular table

HTH