I am facing a problem with my script regarding invoicing. Each invoice has several lines, but only one of the lines state an Account_Number. It is important to note that the Account_Number is not necessarily on Line 1.
For certain operations I need the Account_Number field the way it is, but for others I need all lines filled in with whatever account number was relevant for that invoice. Basically what I need is a new field (Account_Number2) where all lines are filled in. Also some indication on where in my script I put this would be helpful. Should it be in the original table Load statement, or should it be a separate Join, etc.? Can anyone help with this? Thanks!
I cannot load this as an inline table as my real table is HUGE. Almost one million line items. However, is your suggestion here that I load a distinct field with a len() expression. Below is my load statement...is there any way I can augment that in a similar way to what you suggest?
Thanks @ Kranthikumar M. That looks more or less correct to me, but I think I am writing it a bit wrong. Can you help me out? I am not familiar with this expression, but I think where I am wrong are the three variables in the parenthesis. Please see below.