Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Add Ability to Alter Column Names in Data Warehouse Export

Avatar

Avatar
Give Back 5
Level 2
Jeremy_Brugger
Level 2

Likes

5 likes

Total Posts

25 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 1
Validate 1
View profile

Avatar
Give Back 5
Level 2
Jeremy_Brugger
Level 2

Likes

5 likes

Total Posts

25 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
Jeremy_Brugger
Level 2

15-09-2016

We have third-parties that need to ingest Analytics data with specific column names. It would be ideal if we could overwrite column names in the exports.

 

Example:

- Need to send transaction IDs, Orders, Revenue to an FTP

- However, the vendor has strict requirements that these be called ordr_id, ordr_cnt, rv_amt

2 Comments

Avatar

Avatar
Seeker
Level 8
jeff_bloomer
Level 8

Likes

169 likes

Total Posts

250 posts

Correct reply

20 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Ignite 40
Coach
View profile

Avatar
Seeker
Level 8
jeff_bloomer
Level 8

Likes

169 likes

Total Posts

250 posts

Correct reply

20 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Ignite 40
Coach
View profile
jeff_bloomer
Level 8

22-08-2018

Making some general assumptions here, but I’m surprised the customer doesn’t have a more robust ETL process to facilitate the ingestion of an FTP file, regardless of column names, renaming them to whatever they need and then updating their tables accordingly.  In my mind, I would expect that to be an out-of-the-box process for a number of data management systems.  Nice idea, but it makes me wonder about the abilities, or lack thereof, the said system provides.

Avatar

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

363 likes

Total Posts

2,371 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

363 likes

Total Posts

2,371 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile
jantzen_belliston-Adobe
Level 10

27-10-2020

 
Status changed to: Archived