Split Column - 2 columns
I have a file that has a column for postal address that is in this format. Using V2.0 Data Studio
3 Ballarat Street BALLARAT VIC 3000 (not a real address but format is like this)
Address validation what read this as no column. As we are automating all loads direct, l need to be able to split this to 2 columns like this
3 Ballarat Street
BALLARAT VIC 3000
I have tested this and it works. I can do this in excel using flash fill for now, but l am sure a way in Experian.