How to identify element name using text attribute.

[mincharug.shulft]

Really appreciated your support if anyone can help me on this with your past experience.

I have a text file source that has all the account numbers in numeric, and all these numeric numbers are part of my dimension as text attribute, so I while I load the data with respect of my account numbers among all other data load combination I cannot able to load since all these account numbers not directly part of my dimension neither alias.

So is there any way to check with element name associated with this account numbers.

I have attached my screenshot here…..

Capture.PNG (7.68 KiB) Viewed 5095 times

[Alan Kirk]

Really appreciated your support if anyone can help me on this with your past experience.

I have a text file source that has all the account numbers in numeric,

A field containing account numbers, customer codes, table IDs etc should never be treated as a numeric column in a data source unless you like having issues with truncation of leading zeroes for example. They should always be treated as strings so they can be parsed accordingly.

and all these numeric numbers are part of my dimension as text attribute, so I while I load the data with respect of my account numbers among all other data load combination I cannot able to load since all these account numbers not directly part of my dimension neither alias.

So is there any way to check with element name associated with this account numbers.

I have attached my screenshot here…..

Without wishing to state the potentially blindingly obvious... if you put those text attributes in as aliases instead of text attributes, your problem immediately vanishes, does it not?

That is, unless the attributes are not unique, in which case you aren't going to be able to identify a single element from the attribute anyway.

[mincharug.shulft]

Thank you so much alan,but my existed text attribute element used for dfifferent purpose ...so i cannot change that to alias..so is there any another solution that i can use for it.....

[Alan Kirk]

Thank you so much alan,but my existed text attribute element used for dfifferent purpose ...so i cannot change that to alias..so is there any another solution that i can use for it.....

You are aware that there is pretty much no place - reports, rules, whatever - where you can use a text attribute but can't use an alias instead? In some cases you may need to tweak the code slightly, but that isn't always necessary either. The reverse isn't true (in fact the reverse is what you're trying to do, effectively), but an alias can generally be used in exactly the same way as a text attribute can. A DBRA worksheet function, for example, neither knows nor cares whether it's reading a text attribute or an alias. About the only time it matters is if the text attribute can be empty.

And you're doubtless aware that even if it's not possible to convert the existing attribute from a text attribute to an alias for whatever reason... you can create a new alias and populate it with exactly the same values as the text attribute?

[mincharug.shulft]

I really appreciated your help on this,i have got an answer and i impletemented ...thanks again your all suggestions.

[BariAbdul]

Hi mincharug.shulft,It would help everyone in similar situation,If you could post your final solution.Thanks

[mincharug.shulft]

here is my small code.....
Get it my vLOB from source ,and compare with my attribute ,if two are matches then,get that element associated attribute and finally i am using that element as my LOB while doing data....i think it might be understandable .....Thanks again everyone ...the forum is awesome and Alan is rocker of this formum.thanks again Alan.....


DimNam='LOB';
DElem=DIMSIZ(DimNam);
i=1;
While(i<=DElem);
StrEle=DIMNM(DimNam,i);
AOGLOB=ATTRS(DimNam,StrEle,'AOG_LOB');
IF(AOGLOB @=vLOB);
asciioutput('a.txt',StrEle);
LOB=StrEle;
ENDIF;
i=i+1;
END;