convert text from Table B to column name in Table A

[Bagrat_Tsakadze]

Hi community!

I have an issue with "concatenate" function when I get the column name from Table B to Table A, when column names come without square brackets, while each of them denotes column names in Table A. The point is that "Concatenate" function does not recognize those texts as actual column name in Table A, while I wish to get the values from those Table A columns.

Any help would be great...

Awaiting community))

[AleksiAlkio]

Are you trying to read the column header name or values from a column? What have you tried already? Not 100% sure what you are looking for.

[Bagrat_Tsakadze]

Hi Aleksi, thanks for your feedback. 

I have validations rules in Table B, where I have a list of columns names from Table A(Col S01, Col S02, Col S03...)  and prescribed validation rules and attributes. 

In Table "A" I have to generate a comma separated list of Table A columns values by hierarchy that is prescribed in Table "B". 

One way is just to simply use "CONCATENATE" function in Table "A", that is 

CONCATENATE([Col S01], ",", [Col S02], ",", [Col S03]), though I will have to enter formulas every time I add a new logic, keeping in mind that the Columns sequence is specific in every case.  What I am trying to achieve is to get values of Table "A" columns as a comma separated list, by assigning Hierarchy numbers in Table "B"

[Bagrat_Tsakadze]

Hi Aleksi,

Can I provide more details in order to explain better what I wish to reach?

Awaiting your news, 

[AleksiAlkio · Accepted solution]

Unfortunately you are not able to do that. You can't read column names dynamically with a formula.

[Bagrat_Tsakadze]

Thanks 

I will use hense more traditional methods. 
Have a nice day 

[AleksiAlkio]

You're welcome!