Forum Discussion
Filter data and from one table based on data another table and create a slicer from the second table
Hi selimovd , Thank you so much for your prompt response. This looks like the closest solution to my problem and I'm going to give it a try here, Let me get back to you with an answer, i'm hopeful this will work.
selimovd sorry about the late response, but I tried it and i'm stuck at the step where I have to use a delimiter. My code column in table A just has values separated by commas. However, the number of values in there can be dynamic (can be 2 or can be as large as 50, separated by commas). I used the split by delimiter function but somehow it is just allowing me to create just one additional and isnt creating columns equal to dynamic columns with max being max number of values in the code column. I think the B-G use case you explained is not applicable in my case, I'm just trying the rest of the solution