Forum Discussion
Add an index starting from a value in another column
Hi All,
I would like to add an Index in my Query but I want it to start from a value available in another column.
I'm not sure what I should add in the advanced editor to ask to start from a specific value available in column X
Has anyone ever tried to do this please ?
Thank you
Kamel
Hi Anonymous ,
May I ask if you want something like this? When 'Keyword' appears in [Column1], [Index] + 1.
If so, please refer to the solution in this thread.
Solved: Index column only for specific value
If I have misunderstood your needs, please feel free to contact us.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
2 Replies
Hi Anonymous ,
May I ask if you want something like this? When 'Keyword' appears in [Column1], [Index] + 1.
If so, please refer to the solution in this thread.
Solved: Index column only for specific value
If I have misunderstood your needs, please feel free to contact us.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
ppm1Solution Sage
Please provide a few example rows of data to show what you mean. What is the logic to decide which value in the X column is used to start the index?
Pat