Load data with a Wildcard in fields

[PepeMontes]

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.

[QFabian]

Hi @PepeMontes , it is exactly as you said :

Load

Account,

more fields

from [your source]

where 

   Account like 'x1100*';

[Ksrinivasan]

hi,

yes, its possible by using resident table concept:

(Sum(([Account ID] = 'x11000*',Amount) / Sum(([Account ID] =  'x21000*',Amount)) as RazonCirculante

ksrinivasan

[MayilVahanan]

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*');