How to remove a row from a record

[dlprentice]

Hi all,

I know how to remove records from a collection, but not rows from records set to a variable; unless of course the answer is to put the record into a collection, dropcolumns, then get the record again...

Any help is appreciated.

Thanks

[RandyHayes]

@dlprentice 

Rows don't have records...a Record is a Row.  

Are you trying to state that you have a column in your Record that has a table in it?

If so, either way (even with the collection) you cannot alter that directly.  You would need to re-assign it if it is a variable.  If it is a Collection record, then you would need to update the primary row/record of the collection.

I hope this is helpful for you.

[dlprentice]

Hey @RandyHayes,

I think I misspoke; I figured out what I was trying to do though. I had a row that I grabbed from a datasource using a lookup. I wanted to drop one of its "columns".

Perhaps there is an easier way but here is how I got my result that I wanted:

Set(gblData,{Id:1,OP:2,SO:3})

With({_data:DropColumns(Table(gblData),"Id")},Set(gblData,LookUp(_data,SO=3)))