Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to create a sorting field for some of my data but not for others
currently the data looks as follows
Description1
Goods
Assets
Furniture
They must be sorted 1, 2, 3 and the rest of the data must remain the same.
hi
Note sure of this solution for not tested with part of value from a dimension but try to add this before your table :
load * inline [
Description1,
Goods,
Assets,
Furniture] (delimiter is ',') ;
concatenate
load .... etc
So the next table containing this dimension will be order in that way
hi
Note sure of this solution for not tested with part of value from a dimension but try to add this before your table :
load * inline [
Description1,
Goods,
Assets,
Furniture] (delimiter is ',') ;
concatenate
load .... etc
So the next table containing this dimension will be order in that way