cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jeanshak
Level: Powered On

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

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 ???? 

 

 

Jens Rogge
1 ACCEPTED SOLUTION

Accepted Solutions
jeanshak
Level: Powered On

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

Found Solution ! 

inkl. store on the device! 


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

Yeah!

Jens Rogge
3 REPLIES 3
jeanshak
Level: Powered On

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

Found Solution ! 

inkl. store on the device! 


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

Yeah!

Jens Rogge
rgparisoto
Level: Powered On

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

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
Level: Powered On

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

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