Select() does not return rows

[Rahul_Sanghavi]

Hi,

I have two tables.

First, SalesInvoices and second one is, SalesShipment.

SalesInvoices has a column (datatype: text) having list of SalesShipments against the SalesInvoice. This list is comma seperated. This list is created in google sheet using some formulas for each row.

Now, I have created a new virtual column in table SalesInvoices with the following formula.

select(SalesShipment[ShipmentCode],in([ShipmentCode],list([_THISROW].[ShipmentCodes])))

Now, this works fine if the list of saleshipments has only one value but fails if the list has multiple values separated with a comma.

I guess i am doing something wrong which i am not able to arrest.

Please advise.

[Suvrutt_Gurjar · Accepted solution]

Your requirement is not clear.

However, in general it sounds that you may need to flatten the comma separated list that you are calling by the argument [_THISROW].[ShipmentCodes] by using SPLIT()

Maybe something like SPLIT([_THISROW].[ShipmentCodes], ", ")

Please take a look at the following article and posts

help.appsheet.com

SPLIT()

List from text

[Rahul_Sanghavi]

Noted. I will try with your option.

[Rahul_Sanghavi]

Perfect. I got the result i was expecting.

Thanks.