Select() does not return rows

AppSheet AppSheet Q&A
, ,
1

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.

3X_3_f_3f9d07f2a04d99c84c44b55df6533120dd66a11e.png
3X_3_f_3f9d07f2a04d99c84c44b55df6533120dd66a11e.png1872×633 56.5 KB

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

Please advise.

2

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

3 Likes
3

Noted. I will try with your option.

1 Like
4

Perfect. I got the result i was expecting.

Thanks.

2 Likes