Error generation of the scheme

Posted by: superbluesman on 3 August 2017, 3:56 pm EST

  • Posted 3 August 2017, 3:56 pm EST

    Hi !



    I connect Active Analysis to Excel (see below).

    Captions (data in first row of sheet) have space, therefore I get error (see picture).

    If I remove space in captions (e.g. "Date Of X" --> "DateOfX") it work successfully.



    Whether it is possible to make so, what the Active Analysis itself processed records with blanks without manual intervention?



    '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

    Dim qString As String = "SELECT * FROM [Sheet1$]"

    With _RdData_Source

    If .IsConnected Then

    .Disconnect()

    End If

    .ConnectionString = _myConnString

    .ConnectionType = ConnectionType.OleDb

    .QueryString = qString

    .CustomSchemaFile = Me.PrepareRelationalSchema(qString)

    .Connect()

    End With

    Me.pivotView.DataSource = _RdData_Source




    2010/07/1-6.PNG
  • Replied 3 August 2017, 3:56 pm EST

    superbluesman,

    We have a Case 117942 opened to address this issue.

    Thank you,
    Andrey T.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels