topic Re: Two tables with same field name, got response status=400. Resolved by change one of the same field name to different name. in All Apps and Add-ons

Two tables with same field name, got response status=400. Resolved by change one of the same field name to different name.

johnhsu — Mon, 31 Dec 2018 17:53:45 GMT

Two tables with same field name issue.

PowerShell will automatically rename the second name with suffix number.

In SolarWinds Add-on for Splunk, two tables with same field name will got response status=400
Resolved by change one of the same field name to different name.

For example:
SELECT CN.NodeID, CN.SysName, N.IPAddress, N.SysName as Node_SysName FROM Cirrus.Nodes AS CN LEFT JOIN Orion.Nodes AS N ON CN.CoreNodeID = N.NodeID

Re: Two tables with same field name, got response status=400. Resolved by change one of the same field name to different name.

richgalloway — Mon, 31 Dec 2018 18:19:11 GMT

@johnhsu Please rewrite your solution into a question and then post and accept the answer. This will help future readers with similar problem find your resolution.

Re: Two tables with same field name, got response status=400. Resolved by change one of the same field name to different name.

woodcock — Tue, 01 Jan 2019 04:32:22 GMT

What @richgalloway said, @johnhsu!