@Blancitaloca
Add an ID column to your dataset. It can be sequential numbers. Then split the table in two, say at 100 columns and 7 columns. Add both tables as static Excel tables. Then in the OnStart property of the app, create a collection using AddColumns to merge the additional 7 columns from the small table to the big table based on the common ID column.
Collect(
coltable,
With({_littletable:RenameColumns(
littletable,"ID","IDlt"
)
},
AddColumns(
bigtable,"Column101",Lookup(_littletable,IDlt=ID,Column101),
"Column102",Lookup(_littletable,IDlt=ID,Column102), etc
)
)
)
The "With()" in the above formula is to disambiguate the ID between the tables. You can then use coltable in your app in your formulas. Another way to do the disambiguation without using RenameColumns() is as follows:
ClearCollect(
coltable,
AddColumns(
table1,
"c101",
LookUp(
table2,
ID = table1[@ID],
Column101,
"c102",
LookUp(
table2,
ID = table1[@ID],
Column102, //...etc.
)
)
)
