Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello dear Experts,
I want ot load data with the next logic:
I have a field called "Account" which contains many logs who start with this structutre "x11000-0000-0000", "x11000-1000-2000", etc.
Is that possible to make a wildcard to load all the data of this field which start with "x1100*" like a wildcard load or something?
Im setting some operation into the the script which contemplate many logs of this fields, but put every row that i want of this field could be a really long operation, thats why im looking to use something like a wildcard load.
Example:
[Account ID] = 'x11000*' / [Account ID] = 'x21000*' as RazonCirculante
I would greatly appreciate your help.
Regards.
Hi @PepeMontes , it is exactly as you said :
Load
Account,
more fields
from [your source]
where
Account like 'x1100*';
hi,
yes, its possible by using resident table concept:
(Sum(([Account ID] = 'x11000*',Amount) / Sum(([Account ID] = 'x21000*',Amount)) as RazonCirculante
ksrinivasan
Hi @PepeMontes
For wildcard, we can use wildmatch() function.
Ex: if(WildMatch([Account ID] , 'x11000*' ), 1, 0)
or
Load * from ursource where WildMatch([Account ID] , 'x11000*' , 'x21000*');