Hello
I'm trying to transform data that looks like this:
COMPANY NAME |
COMPANY ACC |
AVAILABLE BALANCE |
****.** |
BALANCE |
****.** |
COMPANY NAME |
COMPANY ACC |
BALANCE |
****.** |
The second part of the data I have doesn't have the "available balance" in. I've looked through here and see what I can do and came across the Sample tool but not sure how I can use it if my N number isn't fixed? I've also tried to use transpose and crosstabbing but no luck there either. Is there another tool I can have a look at?
Thanks in advance
For data like this, not fully structured, the challenge is to develop rules that can always be relied upon, to identify field names and field values.
After the word "Balance", it looks like:
I don't fully understand these "rules" for your data, so the best I can do is guess.
Once you develop rules like this, use a Formula tool or Multi-row tool to clearly identify each "value" in your original data as either a Field Name or a Value.
Chris
Thank you, Chris! I will see where I get up to. It's frustrating because the data is so inconsistent.