Forum

@riny Thanks Riny, I'm still trying to work out if I can convert the Table.AddColumn to a function that allows me to use Table.TransformColumn inste...

@riny Hi Riny, It's still very much of relevance to me and I've been working on it for a couple of days. You're right - I was looking for too compl...

Hi again, I've made some progress and, noting @riny's invaluable formula, I'm still trying to develop my M-Code skills by using PQ. I've attached a...

@riny You're right, of course! Nonetheless, a further point is that I needed to use PQ to create the data that I showed in simplistic form in my ex...

@riny, thanks for a great formula solution. To be honest, I was already working on a formula solution in case I couldn't do it in PQ, to meet my dea...

Hi again,Having thought about it further overnight (in UK), I think my question boils down to finding a function that takes a text string and tests ea...

Hi Riny, Very many thanks - I was struggling with the List.Transform ... each Number.From(_) part of the wrap syntax and it was driving me crazy! ...

Hi Anders, Thanks for the reply and sorry for the late response - I've been offline for a while. Unfortunately, this doesn't hep and Cognito Forms...

Thanks Riny - I shan't worry about it then!

Hi Riny, That's perfect - many thanks indeed - and a great way to bring together PQ and Excel tables. Perhaps the developers might introduce an "I...

Hi, I've attached a sample as suggested. The orange table is the original list of orders; the blue table is the filter list, which I want to form ...