Forum Discussion
Extract Attribute (column name) from data living in a cell
I'm trying to create a backwards formula (extraction):
That will find the attribute (column name)in a All Columns value (based on data in a created formula.)
For example,
Column 1 Column 2 Column 3 Column 4 All Columns Backward Formula Extraction
25 feet. 2 towels Black No value 2 Towels, Black Column 1, Column 2, Column 3, Column 4
6 Replies
- since you asked for help on this post I assume the post by peiyezhu didn't help. Can you please explain what you need a little better? unfortunately the text formatting makes it really hard to read and even if I'm reading it correctly I still don't get it. Maybe attach an example file or if it won't let you do that you can share it on Sharepoint or Onedrive or similar or you can PM it to me. another option is to the 'Table' tool in the editor here to at least make the data line up. Regardless, please include additional information about what you have and what you want.
- I'm trying to figure out if I have a paragraph of data...if the data in one cell of the column is in it...and then if it is, capture that column header, so I can backward out a formula to create that paragraph for other cells. Hope that makes sense.
- I can't really make sense of it all but you can check if Col X data is in the paragraph by using
ISNUMBER(SEARCH( ... ) )
If you want to do all the columns dynamically you can use LAMBDA and a helper function like MAP or BYCOL or REDUCE to cycle through all the elements.
I would write something more specific but I still don't get what is needed.
What I get so far is you have table with X columns or data and then in column Y you have paragraph and want to know which columns of data have values found in that paragraph. and the final output should be what? a list of column titles? is that a list in 1 cell or and array of cells? and what is that about create that paragraph for other cells?
is that paragraph an 'ordered list' of prior column values and you want to have the same 'ordered list' but using values from a different row?
