This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
I think both a Transpose and a batch macro would be the best way to make this happen. I went ahead and built an example of this and attached it to this workflow. This workflow also shows how you could use a Transpose to determine the field and then manually update a Dynamic Select tool with the field number to cut off at.