Google Analytics Transaction ID failed to Parse
Hi all,
I've read through the other replies on this topic, but none seem to help.
I am attempting to join our CMS data with Google Analytics via 'Transaction ID'.
When I do so, I continually receive the error message: Failed parse text '1234567890-loc' from column 'Transaction ID' as type 'Integer'.
*sample number, not the actual digits
Things I have tried:
- 'Text Formatting' to show only numbers
- 'Alter Column' turning Transaction ID into text (as well as its counterpart on the other data set)
- 'String Operations' to remove spaces on both ends
- Various combinations of the above 3
What else can I do?
Thanks!
-
Answers
-
Hi @user027926
if you only want the numbers from your ID field then you’d need to remove non-digits from your field and then convert it to a number (assuming both fields should be numeric)
Have you tried a replace text using a regular expression?
‘’’
[^\d]
’’’
Make sure you select the Use RegEx option from the config menu in the replace text field and have it replace with an empty string
(I’m on mobile sorry for the poor formatting)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive