Dynamic select :Select all columns if it does not contain a string

I am having a data set which will have a varying number of columns each time i run.I am using a join so i will be getting the column headers as "Header" and "Right_Header".

I am trying to use dynamic select to remove/deselect all the columns which contains "Right_".(I will doing a calculation on the joined data post which I want remove then from the output)

Thanks

Nidhin

Dynamic Processing

Accepted answers

CharlieS

The Dynamic Select tool can take care of this for you. This statement can be used in the "Select via Formula" mode to deselect any fields with a name that begins with "Right_":

IF left([Name],6)=="Right_" THEN "false"
ELSE "true" ENDIF

All comments

CharlieS

The Dynamic Select tool can take care of this for you. This statement can be used in the "Select via Formula" mode to deselect any fields with a name that begins with "Right_":

IF left([Name],6)=="Right_" THEN "false"
ELSE "true" ENDIF

NidhinGD

Hi Charlie S,

Thanks a lot for the solution.

Hope I can trouble you with another related query .

I am expecting my output to be as follows wherein i will not know the Column names before hand.I am trying to set up a formula which will set the Column 2 (Header 2 in the dataset ) as null when column1 is "End of report".Since the column names are dynamically generated i don't have the option to set the formula on name.Instead i am trying to set something up based on the column position.Is there a way to do this without a macro or transpose?

Thanks

Nidhin

Header 1	Header 2	Header 3
End of report	S3 Pre

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703