How can I load data from a table into a collection?

[jeanshak]

I tried the following:
Tabelle1_1 is a table from a connection:
LocBVGewerke is the collection.

ClearCollect(LocBVGewerke; Defaults(Tabelle1_1));;

SaveData(LocBVGewerke; "LocBVGewerke");;

best would be also to filter the data before load into the collection - for example:  ForAll(Tabelle1_1, If( condition on table, .... )

ANY IDEA ???? 

[jeanshak · Accepted solution]

Found Solution ! 

inkl. store on the device! 


Clear(LocBVGewerke);;
ClearCollect(LocBVGewerke; Filter( Tabelle1_1; Value(blnr)=Value(BLDropDown.Selected.BLNR) ));;
SaveData(LocBVGewerke; "LocBVGewerke");;

Yeah!

[rgparisoto]

Hi Jens!

I have the same problem here, but I want to input only four columns at the collection. 

Do you have some idea about how to to it?

Best regards from Brazil.

Robson.

[JacorA]

Use DropColumns(Filter('your source';'your filter');"first column name to drop";"second column name to drop")